<?

	$rc_license              = mysql_escape_string(trim($_POST[licensenumber]));
	$rc_license_Issue        = mysql_escape_string(trim($_POST[licenseissue]));
	$rc_license_office       = mysql_escape_string(trim($_POST[licensephone]));
    $rc_pr1_cpname           = mysql_escape_string(trim($_POST[companyname1]));
    $rc_pr1_ctname           = mysql_escape_string(trim($_POST[contactname1]));
    $rc_pr1_phone            = mysql_escape_string(trim($_POST[phonenumber1]));
    $rc_pr1_email            = mysql_escape_string(trim($_POST[email1]));
	$rc_pr1_relationship     = mysql_escape_string(trim($_POST[relationship1]));
    $rc_pr2_cpname           = mysql_escape_string(trim($_POST[companyname2]));
    $rc_pr2_ctname           = mysql_escape_string(trim($_POST[contactname2]));
    $rc_pr2_phone            = mysql_escape_string(trim($_POST[phonenumber2]));
    $rc_pr2_email            = mysql_escape_string(trim($_POST[email2]));
	$rc_pr2_relationship     = mysql_escape_string(trim($_POST[relationship2]));
    $rc_pr3_cpname           = mysql_escape_string(trim($_POST[companyname3]));
    $rc_pr3_ctname           = mysql_escape_string(trim($_POST[contactname3]));
    $rc_pr3_phone            = mysql_escape_string(trim($_POST[phonenumber3]));
    $rc_pr3_email            = mysql_escape_string(trim($_POST[email3]));
	$rc_pr3_relationship     = mysql_escape_string(trim($_POST[relationship3]));
   
    $sql = "UPDATE ".$db_prefix."recuiter 
	                 SET 
                    `rc_license`              ='".$rc_license."' ,
					`rc_license_Issue`        ='".$rc_license_Issue."',
					`rc_license_office`       ='".$rc_license_office."'  ,
					`rc_pr1_cpname`           ='".$rc_pr1_cpname."',
					`rc_pr1_ctname`           ='".$rc_pr1_ctname."',
					`rc_pr1_phone`            ='".$rc_pr1_phone."',
					`rc_pr1_email`            ='".$rc_pr1_email."',
					`rc_pr1_relationship`     ='".$rc_pr1_relationship."',
					`rc_pr2_cpname`           ='".$rc_pr2_cpname."',
					`rc_pr2_ctname`           ='".$rc_pr2_ctname."',
					`rc_pr2_phone`            ='".$rc_pr2_phone."',
					`rc_pr2_email`            ='".$rc_pr2_email."',
					`rc_pr2_relationship`     ='".$rc_pr2_relationship."',
					`rc_pr3_cpname`           ='".$rc_pr3_cpname."',
					`rc_pr3_ctname`           ='".$rc_pr3_ctname."',
					`rc_pr3_phone`            ='".$rc_pr3_phone."',
					`rc_pr3_email`            ='".$rc_pr3_email."',
					`rc_pr3_relationship`     ='".$rc_pr3_relationship."'
					WHERE rc_id= '".$_POST[id]."'";
	$DB->query($sql);
	$err =  "<h3 style=\"color:red\">Your change has been successfully updated!!</h3><meta http-equiv=\"refresh\" content=\"2;URL=".$_SESSION[homeUrl]."\">";


?>